CREATE     PROCEDURE [dbo].[asi_PrcQueryGenericRuleFilters]
    @ruleKey uniqueidentifier
    AS
BEGIN
    SELECT rc.RuleCriterionKey, rf.RuleFilterKey, rc.ObjectName, rf.PropertyName, cr.ComparisonDesc,
           rf.ValueOne, rf.ValueTwo
          FROM RuleCriterion rc
         INNER JOIN RuleFilter rf ON rc.RuleCriterionKey = rf.RuleCriterionKey
         INNER JOIN ComparisonRef cr ON rf.ComparisonCode = cr.ComparisonCode
         WHERE rc.RuleKey = @ruleKey
END

GO